﻿

if not Exists(select * from sysobjects where name = 'NewsLetterEmailRecipientByEmailListSource' and Xtype = 'U') 
Begin

	Create table dbo.NewsLetterEmailRecipientByEmailListSource (
		Id int identity(1,1) not null,
		EmailListSourceId int not null,
		EmailRecipientId int not null
	)

	alter table dbo.NewsLetterEmailRecipientByEmailListSource add Constraint PK_NewsLetterEmailRecipientByEmailListSource_Id primary key (Id)

End